Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 1096 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 85.6 KiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 9 |
|---|
FREQUENCIA BOMBA 1 is highly overall correlated with FREQUENCIA BOMBA 2 and 7 other fields | High correlation |
FREQUENCIA BOMBA 2 is highly overall correlated with FREQUENCIA BOMBA 1 and 7 other fields | High correlation |
NIVEL DO RESERVATÓRIO - LT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE ENTRADA- FT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE GRAVIDADE - FT02 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
VAZÃO DE RECALQUE - FT03 is highly overall correlated with FREQUENCIA BOMBA 1 and 7 other fields | High correlation |
PRESSÃO DE SUCÇÃO - PT01 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
PRESSÃO DE RECALQUE - PT02 is highly overall correlated with FREQUENCIA BOMBA 1 and 6 other fields | High correlation |
FREQUENCIA BOMBA 3 is highly overall correlated with FREQUENCIA BOMBA 1 and 2 other fields | High correlation |
NIVEL DO RESERVATÓRIO - LT01 has unique values | Unique |
VAZÃO DE ENTRADA- FT01 has unique values | Unique |
VAZÃO DE GRAVIDADE - FT02 has unique values | Unique |
VAZÃO DE RECALQUE - FT03 has unique values | Unique |
PRESSÃO DE SUCÇÃO - PT01 has unique values | Unique |
PRESSÃO DE RECALQUE - PT02 has unique values | Unique |
FREQUENCIA BOMBA 2 has 125 (11.4%) zeros | Zeros |
FREQUENCIA BOMBA 3 has 767 (70.0%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-29 23:13:59.416704 |
|---|---|
| Analysis finished | 2022-11-29 23:14:24.240527 |
| Duration | 24.82 seconds |
| Software version | pandas-profiling vv3.5.0 |
| Download configuration | config.json |
FREQUENCIA BOMBA 1
Real number (ℝ)
| Distinct | 1086 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.830497 |
| Minimum | 0 |
|---|---|
| Maximum | 57.884742 |
| Zeros | 8 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15.200479 |
| Q1 | 50.491298 |
| median | 54.203522 |
| Q3 | 54.818361 |
| 95-th percentile | 55.871695 |
| Maximum | 57.884742 |
| Range | 57.884742 |
| Interquartile range (IQR) | 4.327063 |
Descriptive statistics
| Standard deviation | 12.354038 |
|---|---|
| Coefficient of variation (CV) | 0.2529984 |
| Kurtosis | 5.0811887 |
| Mean | 48.830497 |
| Median Absolute Deviation (MAD) | 0.97851443 |
| Skewness | -2.4214445 |
| Sum | 53518.224 |
| Variance | 152.62224 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 0.7% |
| 10.45626259 | 2 | 0.2% |
| 16.33021418 | 2 | 0.2% |
| 6.707071304 | 2 | 0.2% |
| 54.159537 | 1 | 0.1% |
| 27.99845457 | 1 | 0.1% |
| 49.66352145 | 1 | 0.1% |
| 54.37093751 | 1 | 0.1% |
| 54.06932179 | 1 | 0.1% |
| 54.13174645 | 1 | 0.1% |
| Other values (1076) | 1076 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 0.07812268396 | 1 | 0.1% |
| 0.1135240048 | 1 | 0.1% |
| 1.457959493 | 1 | 0.1% |
| 1.458722432 | 1 | 0.1% |
| 1.874671936 | 1 | 0.1% |
| 2.138453166 | 1 | 0.1% |
| 2.416199684 | 1 | 0.1% |
| 5.207150777 | 1 | 0.1% |
| 5.62386322 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 57.88474162 | 1 | |
| 57.80188862 | 1 | |
| 57.78695647 | 1 | |
| 57.72492854 | 1 | |
| 57.67244562 | 1 | |
| 57.64668687 | 1 | |
| 57.41708151 | 1 | |
| 57.29679441 | 1 | |
| 57.24754477 | 1 | |
| 57.23739465 | 1 |
| Distinct | 972 |
|---|---|
| Distinct (%) | 88.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.538055 |
| Minimum | 0 |
|---|---|
| Maximum | 53.488396 |
| Zeros | 125 |
| Zeros (%) | 11.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 13.288937 |
| median | 19.964554 |
| Q3 | 22.791507 |
| 95-th percentile | 28.666501 |
| Maximum | 53.488396 |
| Range | 53.488396 |
| Interquartile range (IQR) | 9.5025693 |
Descriptive statistics
| Standard deviation | 9.2819229 |
|---|---|
| Coefficient of variation (CV) | 0.52924471 |
| Kurtosis | 0.87398756 |
| Mean | 17.538055 |
| Median Absolute Deviation (MAD) | 4.0445266 |
| Skewness | -0.18571838 |
| Sum | 19221.709 |
| Variance | 86.154093 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 125 | 11.4% |
| 22.60313161 | 1 | 0.1% |
| 22.0105052 | 1 | 0.1% |
| 21.64428806 | 1 | 0.1% |
| 8.716883262 | 1 | 0.1% |
| 21.35145617 | 1 | 0.1% |
| 20.46317196 | 1 | 0.1% |
| 18.66628154 | 1 | 0.1% |
| 20.38431411 | 1 | 0.1% |
| 19.8963955 | 1 | 0.1% |
| Other values (962) | 962 |
| Value | Count | Frequency (%) |
| 0 | 125 | |
| 0.02895935582 | 1 | 0.1% |
| 0.9161264896 | 1 | 0.1% |
| 1.041552226 | 1 | 0.1% |
| 1.104533116 | 1 | 0.1% |
| 1.124928713 | 1 | 0.1% |
| 1.249832153 | 1 | 0.1% |
| 1.290262143 | 1 | 0.1% |
| 1.301844279 | 1 | 0.1% |
| 1.343984286 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 53.48839553 | 1 | |
| 52.76372433 | 1 | |
| 52.23364218 | 1 | |
| 50.31093295 | 1 | |
| 50.30937306 | 1 | |
| 50.05674442 | 1 | |
| 48.09578911 | 1 | |
| 47.95462648 | 1 | |
| 47.28153245 | 1 | |
| 46.25633566 | 1 |
| Distinct | 310 |
|---|---|
| Distinct (%) | 28.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2986567 |
| Minimum | 0 |
|---|---|
| Maximum | 46.841334 |
| Zeros | 767 |
| Zeros (%) | 70.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2.3758656 |
| 95-th percentile | 27.675307 |
| Maximum | 46.841334 |
| Range | 46.841334 |
| Interquartile range (IQR) | 2.3758656 |
Descriptive statistics
| Standard deviation | 8.9756603 |
|---|---|
| Coefficient of variation (CV) | 2.0880151 |
| Kurtosis | 3.8120072 |
| Mean | 4.2986567 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.1992915 |
| Sum | 4711.3278 |
| Variance | 80.562478 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 767 | |
| 9.664798737 | 18 | 1.6% |
| 7.248599052 | 3 | 0.3% |
| 4.832399368 | 2 | 0.2% |
| 23.63431787 | 1 | 0.1% |
| 25.701382 | 1 | 0.1% |
| 26.63184325 | 1 | 0.1% |
| 30.24013567 | 1 | 0.1% |
| 26.63075733 | 1 | 0.1% |
| 26.53662793 | 1 | 0.1% |
| Other values (300) | 300 | 27.4% |
| Value | Count | Frequency (%) |
| 0 | 767 | |
| 0.003777491899 | 1 | 0.1% |
| 0.01784148306 | 1 | 0.1% |
| 0.02218056515 | 1 | 0.1% |
| 0.02251497004 | 1 | 0.1% |
| 0.02712027091 | 1 | 0.1% |
| 0.04579362473 | 1 | 0.1% |
| 0.04781429508 | 1 | 0.1% |
| 0.05635319138 | 1 | 0.1% |
| 0.0617486091 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 46.84133418 | 1 | |
| 44.46157153 | 1 | |
| 41.99538366 | 1 | |
| 40.82297285 | 1 | |
| 38.32062356 | 1 | |
| 36.97235439 | 1 | |
| 35.73849392 | 1 | |
| 35.44564088 | 1 | |
| 34.455494 | 1 | |
| 33.64279477 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5445124 |
| Minimum | 1.4588396 |
|---|---|
| Maximum | 4.255611 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 1.4588396 |
|---|---|
| 5-th percentile | 2.6396807 |
| Q1 | 3.3451235 |
| median | 3.6440865 |
| Q3 | 3.842757 |
| 95-th percentile | 4.0744165 |
| Maximum | 4.255611 |
| Range | 2.7967713 |
| Interquartile range (IQR) | 0.49763351 |
Descriptive statistics
| Standard deviation | 0.43764183 |
|---|---|
| Coefficient of variation (CV) | 0.12347025 |
| Kurtosis | 1.8624724 |
| Mean | 3.5445124 |
| Median Absolute Deviation (MAD) | 0.23137046 |
| Skewness | -1.2605793 |
| Sum | 3884.7856 |
| Variance | 0.19153037 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.085867832 | 1 | 0.1% |
| 3.745542735 | 1 | 0.1% |
| 4.044858406 | 1 | 0.1% |
| 3.92645368 | 1 | 0.1% |
| 3.875668506 | 1 | 0.1% |
| 3.984868606 | 1 | 0.1% |
| 3.875286599 | 1 | 0.1% |
| 3.5516828 | 1 | 0.1% |
| 3.782529573 | 1 | 0.1% |
| 3.434288959 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 1.458839649 | 1 | |
| 1.731062333 | 1 | |
| 1.836630325 | 1 | |
| 1.854625116 | 1 | |
| 1.921951505 | 1 | |
| 1.963316371 | 1 | |
| 1.973054121 | 1 | |
| 1.975009809 | 1 | |
| 2.047676899 | 1 | |
| 2.107955938 | 1 |
| Value | Count | Frequency (%) |
| 4.255610963 | 1 | |
| 4.238957544 | 1 | |
| 4.234671116 | 1 | |
| 4.22364532 | 1 | |
| 4.218583852 | 1 | |
| 4.203865339 | 1 | |
| 4.201150844 | 1 | |
| 4.19982486 | 1 | |
| 4.196092864 | 1 | |
| 4.194925229 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 211.77062 |
| Minimum | 22.853874 |
|---|---|
| Maximum | 301.86282 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 22.853874 |
|---|---|
| 5-th percentile | 112.36344 |
| Q1 | 195.94412 |
| median | 215.7909 |
| Q3 | 238.32501 |
| 95-th percentile | 270.51985 |
| Maximum | 301.86282 |
| Range | 279.00895 |
| Interquartile range (IQR) | 42.380893 |
Descriptive statistics
| Standard deviation | 44.496078 |
|---|---|
| Coefficient of variation (CV) | 0.2101145 |
| Kurtosis | 3.2839285 |
| Mean | 211.77062 |
| Median Absolute Deviation (MAD) | 20.974483 |
| Skewness | -1.4394381 |
| Sum | 232100.6 |
| Variance | 1979.9009 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 164.09419 | 1 | 0.1% |
| 183.7702262 | 1 | 0.1% |
| 217.3601926 | 1 | 0.1% |
| 239.730663 | 1 | 0.1% |
| 204.170449 | 1 | 0.1% |
| 187.2899815 | 1 | 0.1% |
| 233.0458415 | 1 | 0.1% |
| 207.7327532 | 1 | 0.1% |
| 209.3796951 | 1 | 0.1% |
| 211.6505432 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 22.85387429 | 1 | |
| 23.67098368 | 1 | |
| 45.13681835 | 1 | |
| 45.76276124 | 1 | |
| 45.82522564 | 1 | |
| 46.14894212 | 1 | |
| 46.38032131 | 1 | |
| 53.48451341 | 1 | |
| 53.76006223 | 1 | |
| 55.46804079 | 1 |
| Value | Count | Frequency (%) |
| 301.8628197 | 1 | |
| 292.774423 | 1 | |
| 291.8711243 | 1 | |
| 291.7827042 | 1 | |
| 290.2942263 | 1 | |
| 289.9922231 | 1 | |
| 286.9505081 | 1 | |
| 286.6973852 | 1 | |
| 284.5989176 | 1 | |
| 284.3868116 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.80499 |
| Minimum | 3.5839761 |
|---|---|
| Maximum | 181.56548 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 3.5839761 |
|---|---|
| 5-th percentile | 71.409512 |
| Q1 | 105.09567 |
| median | 115.73304 |
| Q3 | 126.24638 |
| 95-th percentile | 142.2588 |
| Maximum | 181.56548 |
| Range | 177.9815 |
| Interquartile range (IQR) | 21.150711 |
Descriptive statistics
| Standard deviation | 21.485903 |
|---|---|
| Coefficient of variation (CV) | 0.18879579 |
| Kurtosis | 2.9465071 |
| Mean | 113.80499 |
| Median Absolute Deviation (MAD) | 10.565998 |
| Skewness | -1.0775689 |
| Sum | 124730.26 |
| Variance | 461.64401 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 96.5663263 | 1 | 0.1% |
| 119.660035 | 1 | 0.1% |
| 118.927659 | 1 | 0.1% |
| 107.7398957 | 1 | 0.1% |
| 108.8922803 | 1 | 0.1% |
| 107.5259803 | 1 | 0.1% |
| 101.8270885 | 1 | 0.1% |
| 121.2368592 | 1 | 0.1% |
| 110.7362493 | 1 | 0.1% |
| 125.9014478 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 3.58397611 | 1 | |
| 15.88854376 | 1 | |
| 33.55565643 | 1 | |
| 34.30063144 | 1 | |
| 34.70834827 | 1 | |
| 35.52933693 | 1 | |
| 36.82452377 | 1 | |
| 37.51810519 | 1 | |
| 37.73271974 | 1 | |
| 38.05954901 | 1 |
| Value | Count | Frequency (%) |
| 181.565478 | 1 | |
| 177.4906346 | 1 | |
| 173.0618277 | 1 | |
| 169.2136116 | 1 | |
| 166.4727999 | 1 | |
| 165.6624734 | 1 | |
| 165.2773012 | 1 | |
| 165.0567973 | 1 | |
| 163.15286 | 1 | |
| 162.393026 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.13861 |
| Minimum | 10.383355 |
|---|---|
| Maximum | 143.98841 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 10.383355 |
|---|---|
| 5-th percentile | 44.08095 |
| Q1 | 99.238742 |
| median | 104.84557 |
| Q3 | 110.00566 |
| 95-th percentile | 118.0335 |
| Maximum | 143.98841 |
| Range | 133.60506 |
| Interquartile range (IQR) | 10.766917 |
Descriptive statistics
| Standard deviation | 19.821714 |
|---|---|
| Coefficient of variation (CV) | 0.19794277 |
| Kurtosis | 5.4573128 |
| Mean | 100.13861 |
| Median Absolute Deviation (MAD) | 5.3458869 |
| Skewness | -2.2501613 |
| Sum | 109751.92 |
| Variance | 392.90037 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 78.38720433 | 1 | 0.1% |
| 103.3230522 | 1 | 0.1% |
| 99.73705737 | 1 | 0.1% |
| 97.84226386 | 1 | 0.1% |
| 98.00454283 | 1 | 0.1% |
| 97.23211066 | 1 | 0.1% |
| 95.51771514 | 1 | 0.1% |
| 104.9044383 | 1 | 0.1% |
| 98.95222044 | 1 | 0.1% |
| 107.5846831 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 10.38335467 | 1 | |
| 18.78395883 | 1 | |
| 19.01510628 | 1 | |
| 19.22242113 | 1 | |
| 20.09405685 | 1 | |
| 20.10896885 | 1 | |
| 20.59290862 | 1 | |
| 21.63480695 | 1 | |
| 22.6513927 | 1 | |
| 22.69457825 | 1 |
| Value | Count | Frequency (%) |
| 143.9884148 | 1 | |
| 141.122522 | 1 | |
| 140.1231352 | 1 | |
| 137.250213 | 1 | |
| 137.2110043 | 1 | |
| 136.7754704 | 1 | |
| 136.7724743 | 1 | |
| 133.4322859 | 1 | |
| 133.0077931 | 1 | |
| 131.2276457 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4852247 |
| Minimum | 1.924965 |
|---|---|
| Maximum | 5.4753866 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 1.924965 |
|---|---|
| 5-th percentile | 3.537572 |
| Q1 | 4.2449013 |
| median | 4.5707596 |
| Q3 | 4.813108 |
| 95-th percentile | 5.119963 |
| Maximum | 5.4753866 |
| Range | 3.5504217 |
| Interquartile range (IQR) | 0.56820674 |
Descriptive statistics
| Standard deviation | 0.48689463 |
|---|---|
| Coefficient of variation (CV) | 0.10855524 |
| Kurtosis | 1.9289733 |
| Mean | 4.4852247 |
| Median Absolute Deviation (MAD) | 0.26363807 |
| Skewness | -1.1061814 |
| Sum | 4915.8063 |
| Variance | 0.23706638 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.195563376 | 1 | 0.1% |
| 4.652495493 | 1 | 0.1% |
| 4.980844438 | 1 | 0.1% |
| 4.872517745 | 1 | 0.1% |
| 4.8248384 | 1 | 0.1% |
| 4.934429506 | 1 | 0.1% |
| 4.838139951 | 1 | 0.1% |
| 4.440327237 | 1 | 0.1% |
| 4.719303727 | 1 | 0.1% |
| 4.318869789 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 1.924964962 | 1 | |
| 2.168335776 | 1 | |
| 2.599595224 | 1 | |
| 2.656243861 | 1 | |
| 2.743227368 | 1 | |
| 2.755907903 | 1 | |
| 2.801692863 | 1 | |
| 2.920023123 | 1 | |
| 2.923848917 | 1 | |
| 2.925910562 | 1 |
| Value | Count | Frequency (%) |
| 5.475386639 | 1 | |
| 5.469098727 | 1 | |
| 5.428008278 | 1 | |
| 5.420319339 | 1 | |
| 5.40986371 | 1 | |
| 5.409394821 | 1 | |
| 5.394903402 | 1 | |
| 5.376384755 | 1 | |
| 5.376057903 | 1 | |
| 5.329075277 | 1 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.424306 |
| Minimum | 0.83083199 |
|---|---|
| Maximum | 23.678933 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.1 KiB |
Quantile statistics
| Minimum | 0.83083199 |
|---|---|
| 5-th percentile | 5.6923869 |
| Q1 | 19.805492 |
| median | 21.015114 |
| Q3 | 21.140136 |
| 95-th percentile | 21.809401 |
| Maximum | 23.678933 |
| Range | 22.848101 |
| Interquartile range (IQR) | 1.3346445 |
Descriptive statistics
| Standard deviation | 4.3233274 |
|---|---|
| Coefficient of variation (CV) | 0.22257306 |
| Kurtosis | 6.7578239 |
| Mean | 19.424306 |
| Median Absolute Deviation (MAD) | 0.24408048 |
| Skewness | -2.7339197 |
| Sum | 21289.04 |
| Variance | 18.69116 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.06450653 | 1 | 0.1% |
| 20.79550151 | 1 | 0.1% |
| 19.6672767 | 1 | 0.1% |
| 21.73330839 | 1 | 0.1% |
| 20.97606885 | 1 | 0.1% |
| 20.97365777 | 1 | 0.1% |
| 21.27573272 | 1 | 0.1% |
| 21.05959225 | 1 | 0.1% |
| 19.4533143 | 1 | 0.1% |
| 21.08179649 | 1 | 0.1% |
| Other values (1086) | 1086 |
| Value | Count | Frequency (%) |
| 0.8308319853 | 1 | |
| 1.177278982 | 1 | |
| 1.503833353 | 1 | |
| 1.619448689 | 1 | |
| 1.921274748 | 1 | |
| 2.014124649 | 1 | |
| 2.069669306 | 1 | |
| 2.153511247 | 1 | |
| 2.236963258 | 1 | |
| 2.331033865 | 1 |
| Value | Count | Frequency (%) |
| 23.67893306 | 1 | |
| 23.64501381 | 1 | |
| 23.60372647 | 1 | |
| 23.59236177 | 1 | |
| 23.58846887 | 1 | |
| 23.56355182 | 1 | |
| 23.54971107 | 1 | |
| 23.50800292 | 1 | |
| 23.50494107 | 1 | |
| 23.50471417 | 1 |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| FREQUENCIA BOMBA 1 | FREQUENCIA BOMBA 2 | FREQUENCIA BOMBA 3 | NIVEL DO RESERVATÓRIO - LT01 | VAZÃO DE ENTRADA- FT01 | VAZÃO DE GRAVIDADE - FT02 | VAZÃO DE RECALQUE - FT03 | PRESSÃO DE SUCÇÃO - PT01 | PRESSÃO DE RECALQUE - PT02 | |
|---|---|---|---|---|---|---|---|---|---|
| Timestamp | |||||||||
| 2018-01-01 | 45.727617 | 0.916126 | 0.000000 | 4.085868 | 164.094190 | 96.566326 | 78.387204 | 5.195563 | 16.064507 |
| 2018-01-02 | 47.239316 | 0.000000 | 0.000000 | 3.942272 | 181.728099 | 112.688852 | 84.923583 | 5.017492 | 15.573998 |
| 2018-01-03 | 48.112157 | 0.000000 | 0.000000 | 3.883783 | 193.140774 | 113.665250 | 87.072110 | 4.949791 | 15.761076 |
| 2018-01-04 | 49.869415 | 2.681982 | 0.000000 | 3.912685 | 184.679417 | 118.076269 | 90.388552 | 4.961430 | 16.897601 |
| 2018-01-05 | 37.037886 | 19.499752 | 8.569013 | 3.389542 | 211.898758 | 125.748680 | 91.432063 | 4.431274 | 17.123912 |
| 2018-01-06 | 52.575690 | 0.000000 | 18.076194 | 3.787355 | 209.129580 | 107.606394 | 93.396580 | 4.823002 | 20.695101 |
| 2018-01-07 | 48.340235 | 0.000000 | 5.761071 | 4.002495 | 195.953294 | 94.778895 | 81.376922 | 5.109281 | 17.836842 |
| 2018-01-08 | 49.139040 | 0.000000 | 1.882809 | 3.945957 | 163.036853 | 100.778530 | 83.851865 | 5.044049 | 17.733694 |
| 2018-01-09 | 49.933460 | 0.000000 | 0.000000 | 3.875856 | 187.854675 | 100.264018 | 85.714187 | 4.958287 | 17.919003 |
| 2018-01-10 | 50.077934 | 0.000000 | 0.000000 | 3.885556 | 172.007514 | 100.854453 | 85.651196 | 4.971008 | 18.197270 |
| FREQUENCIA BOMBA 1 | FREQUENCIA BOMBA 2 | FREQUENCIA BOMBA 3 | NIVEL DO RESERVATÓRIO - LT01 | VAZÃO DE ENTRADA- FT01 | VAZÃO DE GRAVIDADE - FT02 | VAZÃO DE RECALQUE - FT03 | PRESSÃO DE SUCÇÃO - PT01 | PRESSÃO DE RECALQUE - PT02 | |
|---|---|---|---|---|---|---|---|---|---|
| Timestamp | |||||||||
| 2020-12-22 | 14.038982 | 7.904490 | 0.000000 | 3.700346 | 53.484513 | 63.272562 | 37.828409 | 4.794499 | 4.462368 |
| 2020-12-23 | 57.081451 | 35.992406 | 0.000000 | 2.545013 | 260.922810 | 152.082684 | 116.458936 | 3.373861 | 21.444099 |
| 2020-12-24 | 44.549358 | 27.993427 | 8.423918 | 2.906787 | 254.396596 | 131.572730 | 103.163843 | 3.803207 | 19.937727 |
| 2020-12-25 | 52.124814 | 19.196690 | 0.000000 | 3.958751 | 244.321652 | 113.998204 | 92.009739 | 4.930999 | 19.936115 |
| 2020-12-26 | 52.323723 | 24.571872 | 0.000000 | 3.882665 | 227.833759 | 128.669075 | 100.863805 | 4.812961 | 20.578570 |
| 2020-12-27 | 50.531809 | 13.245138 | 0.000000 | 4.139487 | 221.111380 | 125.413031 | 90.930370 | 5.120144 | 18.466390 |
| 2020-12-28 | 52.091690 | 27.043497 | 0.000000 | 4.194925 | 241.122370 | 129.550738 | 99.452935 | 5.119153 | 20.024225 |
| 2020-12-29 | 52.197896 | 27.251914 | 0.000000 | 4.013414 | 209.975585 | 125.795283 | 99.268892 | 4.948950 | 20.154963 |
| 2020-12-30 | 52.494042 | 27.491388 | 0.000000 | 3.729430 | 208.305455 | 132.392801 | 101.472267 | 4.643748 | 20.081885 |
| 2020-12-31 | 45.617832 | 27.092583 | 7.088465 | 3.775853 | 226.161141 | 124.051831 | 97.103559 | 4.714149 | 20.237162 |